select * from products where pro_name like '%color%ment%' or pro_des like '%color%ment%'union all select * from products where (pro_name like '%color%' or pro_des like '%color%') or(pro_name like '%ment%' or pro_des like '%ment%') and (pro_name not like '%color%ment%' or pro_des not like '%color%ment%')

Dark Green Dress for Sweet 15 with White Appliques On Sale

Latest Simple Green Corset Sweet Sixteen Dresses with Pick Ups

Noble Bowknot Appliqued Watermelon Red Dress for Sweet 15

Two-toned Strapless Ruffles Beaded Sweet Sixteen Dress with Ruche

White and Fuchsia Pick-ups Taffeta Sweet 16 Dresses with Beading

Strapless Blue Quinceanera Party Dresses with Appliques and Bow

Newest Red Ball Gown Strapless Quinceanera Dress with Appliques

Beautiful Aqua Blue Sweet 15 Dresses with Appliques and Ruches

Brand New White Ball Gown Dresses for Sweet 16 with Embroidery

Recommended Strapless Silver Sweet 15 Dresses with Ruffled Layers

Purple and Black Dresses Quinceanera with Appliques and Beading

Hand Made Flowers Purple One Shoulder Sweet 16 Dress

Multi-colored Ruffles Appliques Strapless Quince Dresses Wholesale

Two-toned Dress for Sweet 16 Beading with Ruffled Layers Hot Sale

Multi-layered Sweet Sixteen Dresses with Floral Embellishment

Fabulous Embroidery Taffeta Quinceanera Dresses Strapless in Red

Yellow Strapless Organza Sweet 15 Dresses with Lace Hem Decorate

Recommended Strapless Appliques Sweet 16 Dresses with Beading

Two-toned Ruffles Strapless Sweet 15 Dresses with Beading in Style

Lovely Multi-colored Sweetheart Tulle Quinces Dresses with Beading

Beaded Sweetheart Dress for a Quinceanera with Pick-ups

Burgundy Ball Gown Ruching Sweet Sixteen Dresses with Beading

Noble Burgundy Taffeta Beaded Quinceanera Party Dress with Bow

Multi-tiered Apple Green Sweetheart Quince Gown with Ruffles

Spaghetti Straps Beading Royal Blue Quince Gown with Ruffles

Blue Sweetheart Beading Appliqued Quince Dresses with Pleats

Taffeta Appliqued Sweet 15/16 Birthday Dress with Pick-ups

Appliqued Aqua Blue Dress 15 with Sash and Hand Made Flowers

Strapless Appliqued Quince Party Dress with Colorful Ruffles

Beading Ruffled Fuchsia and Black Quince Dresses with Pick-ups